Best Online Data Analytics Power-BI Training Institute In Delhi (Noida).

Course Content

Module 1: INTRODUCTION TO POWER BI • Introduction to Business Intelligence (BI) • Stages of business intelligence (BI) • Use cases of BI • Various BI tools • Overview of Data warehouse & concepts • Introduction to Power BI • Why Power BI • Power BI Components • Power BI pricing structure • Building blocks of Power BI • Architecture of Power BI • Power BI vs Tableau vs QlikView • Introduction of Power BI Desktop • The key features of Power BI workflow • Process of creating reports in Power BI Hands-on Exercise – • Demo of building a Power BI dashboard • Source data from web • Publish to cloud • Create power tables Module 2: DATA EXTRACTION • Overview of Power BI desktop • Data sources in Power BI • Using files (excel, pdf, csv, etc.) as a data source • Using SaaS connectors • Extracting data from folders, and databases • Working with Azure SQL database and database sources • Connecting to Analysis Services • Other data sources (OData, web, SharePoint etc.) • Python & R script in Power BI • Introduction of power query editor • Advance editor • Query dependency editor Hands-on Exercise – • Connect to a database • Import data from an excel file • Connect to SQL Server • Analysis Service • Connect to Power Query • Connect to SQL Azure • Connect to Hadoop Module 3: DATA TRANSFORMATION – SHAPING & COMBINING DATA • Shaping data using Power Query Editor • Formatting data • Transformation of data • Understanding of Data types • Data profiling for data quality check • Naming conventions & best practices to consider • Working with Parameters • Merge Query • Append Query • Group by of data (aggregation of data) • Applied steps (query settings) • Duplicate & Reference tables • Transpose of data • Fill • Pivot & Un-pivot of data • Custom columns • Conditional columns • Replace data from the tables • Split columns values • Move columns & sorting of data • Detect data type, count rows & reverse rows • Promote rows as column headers • Hierarchies in Power BI • M query Hands-on Exercise – • Install Power BI Desktop and configure the settings • Use Query editor • Write a power query • Transpose a table Module 4: DATA MODELLING & DAX • Introduction of relationships • Creating relationships • Cardinality • Cross filter direction • Use of inactive relationships • Introduction of DAX • Why DAX is used • DAX syntax • DAX functions • Context in DAX • Calculated columns using DAX • Measures using DAX • Calculated tables using DAX • Learning about table, information, logical, text, iterator, • Time intelligence functions (YTD, QTD, MTD) • Cumulative values, calculated tables, and ranking and rank over groups • Date and time functions • DAX advanced features Hands-on Exercise – • Create a Power Pivot Apply filters • Use advanced functionalities like date and time functions • Embed Power Pivot in Power BI Desktop • Create DAX queries for calculate column, tables and measures Module 5: DATA VISUALIZATION WITH ANALYTICS • Deep dive into Power BI data visualization • Understanding Power View and Power Map • Data visualization techniques • Page layout & Formatting • Power BI Desktop visualization • Formatting and customizing visuals • Visualization interaction • Custom visualization in Power BI • Top-down and bottom-up analytics • Drill down • Drill through • Page navigations • Bookmarks • Selection pane to show/hide visuals • Comparing volume and value-based analytics • Combinations charts (dual axis charts) • Filter pane • Slicers • Use of Hierarchies in drill down analysis • Theme for corporate standards • Power BI template for design reusability • Mastering the best practices • Performance analyzer in Power BI for monitoring performance of report • Power BI Q&A (Natural Language Query visual) • Sync slicers • Tooltips & custom tooltips • Tables & matrix • Conditional formatting on visuals • Waterfall chart, KPI, Donut chart, Scatter chart • Geographical data visualization using Maps Hands-on Exercise – • Create a Power View and a Power Map • Format and customize visuals • Deploy Power View on SharePoint and Excel • Implement top-down and bottom-up analytics • Create Power View reports, Charts, Scorecards • Add a custom visual to report • Authenticate a Power BI web application • Embed dashboards in applications • Categorize, filter and sort data using Power View • Create hierarchies • Use date hierarchies • Use business hierarchies • Resolve hierarchy issues Module 6: POWER BI SERVICE (Cloud), Q & A AND DATA INSIGHTS • Introduction to Power BI Service • Introduction of workspaces • Dashboard • Creating & Configuring Dashboards • Dashboard theme • Reports vs Dashboards • Building workspace Apps • Sharing reports & dashboards • Introduction to Power Q & A • Ask questions about your data using Natural Query Language • Getting answers in the form of charts, graphs, and data discovery methodologies • Configure custom questions for Q&A like FAQ • Ad-hoc analytics building • Power Q&A best practices • Quick Insights • Subscribe, Alerts, Usage statics, Related content • Design reports on Power BI Service • Collaboration using Power BI Service • Row Level Security (RLS) • Introduction of Paginated Reports • Introduction of Power BI Report Server Hands-on Exercise – • Write queries using natural language • Get answers in the form of charts, graphs • Build ad hoc analytics • Pin a tile and a range to dashboard Module 7: POWER BI SETTINGS, ADMINISTRATION & DIRECT CONNECTIVITY • Getting to understand Power BI Desktop settings • Aggregating data from multiple data sources • Power BI Service settings • Power BI Admin Portal • Administration activities • Power BI usage analysis • Introduction of Office 365 admin activities • Introduction of Data Gateway • Installation & Configuration of data gateways • Scheduling auto data refresh • Managing groups, row-level security, datasets, reports, and dashboards • Real time data analysis using Direct Connectivity • Direct Query vs Import Mode Hands-on Exercise – • Configure security for dashboard Deploy data gateways • Aggregate data from multiple data sources • Schedule data refresh • Manage groups and row level security, datasets, reports, and dashboards • Work with calculated measures Module 8: EMBEDDED POWER BI WITH API & POWER BI MOBILE • Introduction to embedded Power BI • Create embedded code • Manage embedded code • Integration of Power BI in SharePoint • Introduction of Power BI API • Power BI Embedded playground • Introduction to Power BI Mobile • Creating mobile based reports & dashboards • Optimizing report for Power BI mobile app • Features of Power BI mobile app • Introduction of integrating Power BI & Excel • Power BI Analyze in Excel Hands-on Exercise – • Design Power BI reports for Mobile app • Power BI embedded demo Module 9: POWER BI ADVANCE & POWER BI PREMIUM • Introduction of Power BI Premium • Power BI Premium per user • Power BI Premium features • Introduction to Data Flow • Create Data Flow • Advantages of Data Flow • Create reports using Data Flow • Introduction to Power BI Deployment Pipelines • Create Deployment Pipelines • Benefits of Deployment Pipelines • Introduction of Sensitivity Labels • Introduction of Power BI Goals feature • Incremental data load in Power BI • Power BI best practice rules to improve performance Hands-on Exercise – • Demo of Data Flow • Demo of deployment pipelines • Demo of incremental load of data in Power BI.