We listened to your recommendations, and have schedule weekend classes for March 19th and 26th, with discounted prices.

For NGN50k only you get to Data Analysis Expressions (DAX) LOOKUP, FILTER, CALCULATE, NESTED IF, CONCATENATE, PREDICTIVE ANALYSIS and more

Course details in next reply

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports. Drive better business decisions by analyzing your data for insights.

Learn Data Analysis Expressions (DAX) LOOKUP, FILTER, CALCULATE, NESTED IF, CONCATENATE, PREDICTIVE ANALYSIS and more

Contact kurindeta today

Kurindeta Limited

www.kurindeta.com
www.kurindeta.com/calendar
contactdata@kurindeta.com

1. Introduction to Power BI and self-service Business Intelligence
· Power BI's strength and weakness compared to the other popular BI tools
· Important concepts of Power BI
· Power BI Architecture
· Power BI Service
· Power BI Desktop
· Power BI Mobile
· Power BI Data Gateway

2. Get Data (bringing in your data for analysis)
· D ata Sources in Power BI Desktop
· C onnect to web data and web apps
· Import Excel Workbooks
· Connect to enterprise Databases
· Connect to enterprise applications
· The rule of no intermediary for best benefits

3. Data Transformation, Power Query and DAX
· Get Data - Knowing whether to Load or Edit
· Model section of the report builder (Power BI Desktop)
· Data section of the report builder (Power BI Desktop)
o Data Type
o Data Format
o DAX
o Row level Security
· Report section of the report builder (Power BI Desktop)
o Report creation
o Native Visuals
o Custom Visuals
o Menu Tools for professional looking reports
o Edit Interactions
o Report creation from scratch
· Power Query
o Transforming and Combining Data pre-loading to Model
o Common Power Query tasks
§ U npivot
§ S plit Column
§ A ppend Tables
§ Merge Tables
§ R emove rows
§ U se first row as header
§ P arameters
§ Add Columns
§ Group By
§ Extract
§ Fill
§ Transpose
§ Advanced Query for M code editing
§ Blank Query (M code writing)
· Understanding when to use Power Query or M code and when to use DAX
· Sample Projects

4. Report Publishing, Dashboards and Power BI Service
· Understanding the concept of Workspaces
· Publishing report (from Power BI desktop to Power BI service for consumption)
· Controlling access to aspects of the report by role (region, department or level)
· Published Report options
o Exporting to PowerPoint or PDF
o Embedding in SharePoint
o Embedding in a website
o Making it available via a web link
o Sharing with specific users
o Editing the report – adding new visuals, changing visuals used and creating new report pages
o Adding comments and tagging users
o Scheduling the report to send our daily or weekly to specific people
· Creating a Dashboard
o Can be created from one or more reports to show management useful analysis
o Can incorporate data and visuals from other people's dashboards or reports shared with you
o Add Tile or Streaming data (APIs)
o Set Alerts to be instantly notified when a KPI is reached or an SLA is breached
o Add actionable comments
o Schedule the dashboard to be sent out daily or weekly to specific people
o Share the dashboard with final users
· Best practices
· Setting automatic/scheduled refresh so new data is ingested automatically
· Data Gateway configuration
o The type of data sources that require data gateway

5. AI in Power BI and Apps
· Q&A for auto-generating charts and tables in answer to questions
· Quick Insights for auto-generating reports from datasets
· Creating Apps
· Installing Apps to hasten report creation and prototypes or connect to non-native data source
· Integrating with Python and R

https://www.youtube.com/watch?v=mXnxVmCTWXQ