Course Overview
Microsoft Power BI is the most in demand business intelligence suit that can help in visualizing data and sharing insights. This course covers beginning to advance topics which will make you proficient in connecting data sources, transforming data, building complex data models, great looking highly intuitive reports & dashboards and optimization. You will get to work on real time scenarios and real-life business data from highly experienced industry experts.
Course Modules
You will learn :
- Introduction to Power BI
- Power BI Components
- Power BI pricing structure
- Architecture of Power BI
- Building blocks of Power BI
- Introduction of Power BI Desktop
- Installation of Power BI Desktop
- The key features of Power BI workflow
- Process of creating reports in Power BI
- Data sources in Power BI
- Data importing - from flat file (.csv and .txt), database file (.xlsx and .accdb), Database connection (ODBC and OLEDB), Web files
- Direct Query vs Import Mode
- Introduction of power query editor
- Advance editor
- Formatting and Transforming data using Power Query Editor
- Understanding Data types
- Data profiling & data quality check
- Working with Parameters
- Merge Query
- Append Query
- Applied steps (query settings)
- Transpose
- Pivot & Un-pivot of data
- Custom columns
- Conditional columns
- Replace data in the tables
- Split columns
- Move columns & sorting of data
- Detect data type, count rows & reverse rows
- Promote rows as column headers
- Hierarchies in Power BI
- M query
- Introduction of relationships
- Creating relationships
- Use of inactive relationships
- Cross filter direction
- Cardinality
- Introduction of DAX
- DAX syntax and uses
- DAX functions
- Context in DAX - Row Context and Filter Context
- 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
- Power BI Desktop visualization
- Page layout & Formatting
- Power View and Power Map
- 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
- Visualizations best practices
- Monitoring performance of report using Performance analyzer
- Power BI Q&A (Natural Language Query visual)
- Sync slicers
- Tooltips & custom tooltips
- Conditional formatting on visuals
- Geographical data visualization using Maps
- Introduction to Power BI Service
- Introduction of workspaces
- Creating & Configuring Dashboards
- Reports vs Dashboards
- Building workspace Apps
- Sharing reports & dashboards
- configure subscriptions and data alerts
- Paginated report and Introduction to Power Q & A
- Getting to understand Power BI Desktop settings
- Aggregating data from multiple data sources
- Power BI Service settings
- Power BI Admin Portal
- Administration activities
- Scheduling auto data refresh
- Managing groups, row-level security, datasets, reports, and dashboards
- Introduction of Office 365 admin activities
- Introduction of Power BI Premium
- Introduction of Data Gateway
- Installation & Configuration of data gateways
- Introduction to embedded Power BI
- Introduction to create embedded code
- Manage embedded code
- Integration of Power BI in SharePoint
- Introduction of Power BI API, Power BI Mobile
- Optimizing Power BI reports
- Introduction of integrating Power BI & Excel
- 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
- Introduction to incremental data load in Power BI
- Introduction to AI visuals
FAQ
Any graduate, fresher, experienced and looking to start or change their career into data analytics can attend. No prior experience is mandatory.
Absolutely. We start the training from scratch. After completing the course you will not feel that you have never programmed.
Yes
Our trainers are from the industry. Every class is followed by real time assignments which will make you feel confident when you get into a job.
Fully online. You can attend from anywhere. You just need a laptop and a good internet connection
Yes 100%. It is live and fully interactive. We dont believe in running through power point presentations.
Please contact on the given number.
Contact Us
+91 70198 30464 / +91 79911 97543
Enroll / Enquire
Address : Saroj Iris, No. 106 (Wing A), Gunjur, Varthur Hobli, Bangalore - 560087
Phone : +91 70198 30464 / +91 79911 97543
Email :
info@dakshahanalyticsacademy.com, dakshahanalyticsacademy@gmail.com