You must be logged in to take this course → LOGIN | REGISTER NOW
Power BI is a business analytics service provided by Microsoft that gains popularity in the recent times as a cloud-based service. It offers interactive visualisations with self-service business intelligence capabilities, where end users can create reports and share insights from their organisations’ data.
The [course_title] course focuses on Power BI and teaches you how to connect to and import your data, author reports using Power BI Desktop, and publish those reports to the Power BI service. You will also learn to create dashboards and share the dashboards with business users from both mobile devices and web.
Assessment
This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.
Certification
Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.
Having an Official Edukite Certification is a great way to celebrate and share your success. You can:
- Add the certificate to your CV or resume and brighten up your career
- Show it to prove your success
Course Credit: Microsoft
Course Curriculum
Introduction | |||
Meet the Presenters | 00:01:00 | ||
Introduction | 00:02:00 | ||
Overview of Power BI | 00:05:00 | ||
Connecting to Software as Services | 00:04:00 | ||
Introduction Summary | 00:01:00 | ||
Power BI Desktop Data Transformations | |||
Power BI Desktop Data Transformations – Introduction | 00:01:00 | ||
Connecting to a Database | 00:03:00 | ||
Basic Transformations | 00:07:00 | ||
Managing Query Groups | 00:02:00 | ||
Splitting Columns | 00:03:00 | ||
Changing Data Types | 00:03:00 | ||
Working with Dates | 00:02:00 | ||
Removing and Reordering Columns | 00:02:00 | ||
Conditional Columns | 00:04:00 | ||
Connecting to Files in a Folder | 00:07:00 | ||
Merge Queries | 00:03:00 | ||
Query Dependency View | 00:03:00 | ||
Transforming Less Structured Data | 00:06:00 | ||
Enter Data | 00:04:00 | ||
Query Parameters | 00:06:00 | ||
Power BI Desktop Data Transformations – Summary | 00:01:00 | ||
Power BI Desktop Modelling | |||
Power BI Desktop Modelling – Introduction | 00:02:00 | ||
Managing Data Relationships | 00:05:00 | ||
Creating Calculated Columns | 00:04:00 | ||
Optimizing Models for Reporting | 00:04:00 | ||
Creating Calculated Measures | 00:08:00 | ||
Creating and Managing Hierarchies | 01:06:00 | ||
Using Calculated Tables | 00:02:00 | ||
Time Intelligence | 00:03:00 | ||
Manually Typing in a Data Table | 00:04:00 | ||
Include / Exclude | 00:02:00 | ||
Grouping / Binning | 00:03:00 | ||
Power BI Desktop Modelling – Summary | 00:01:00 | ||
Power BI Desktop Visualization | |||
Power BI Desktop Visualization – Introduction | 00:01:00 | ||
Pie and Treemap | 00:05:00 | ||
Hierarchical Axis and Concatenating | 00:02:00 | ||
Filter (Including TopN) | 00:02:00 | ||
Bar Chart with Line (Combo Chart) | 00:02:00 | ||
Analytics Pane | 00:03:00 | ||
Clustering (and Machine Learning) | 00:05:00 | ||
Slicers | 00:07:00 | ||
Focus Mode and See Data | 00:03:00 | ||
Date Slicer | 00:02:00 | ||
Map Visualizations | 00:03:00 | ||
ESRI Map | 00:06:00 | ||
Table and Matrix | 00:06:00 | ||
Table Styles | 00:02:00 | ||
Scatter Chart | 00:04:00 | ||
Waterfall Chart | 00:02:00 | ||
Gauge, Card, and KPI | 00:06:00 | ||
Coloring Charts | 00:03:00 | ||
Shapes, textboxes and image | 00:03:00 | ||
Gridlines and Snap to Grid | 00:02:00 | ||
Power BI Service | |||
Power BI Service – Introduction | 00:01:00 | ||
Overview of Dashboards and Service | 00:03:00 | ||
Uploading to Power BI Service | 00:01:00 | ||
Quick Insights | 00:04:00 | ||
Configuring a Dashboard | 00:03:00 | ||
Adding Textbox, Image Widgets | 00:02:00 | ||
Featured and Favorite Dashboard | 00:03:00 | ||
Filtering Dashboard | 00:01:00 | ||
Dashboard Settings | 00:02:00 | ||
Natural Language Queries | 00:04:00 | ||
Featured Questions | 00:02:00 | ||
Sharing a Dashboard | 00:03:00 | ||
Focus Mode | 00:02:00 | ||
Pinning a Live Page | 00:02:00 | ||
Custom URL and Title | 00:03:00 | ||
TV Mode and Collapse Navigation | 00:02:00 | ||
Printing Dashboard and Exporting Data | 00:02:00 | ||
Export to CSV and Excel | 00:03:00 | ||
Power BI Notifications | 00:02:00 | ||
Alerts in the Power BI Service | 00:03:00 | ||
Personal Gateway | 00:04:00 | ||
Publishing to Web | 00:02:00 | ||
Admin Portal | 00:03:00 | ||
Viewing Power BI Dashboard | |||
Viewing in Windows App | 00:03:00 | ||
Viewing in Android App | 00:03:00 | ||
Viewing in iPad | 00:02:00 | ||
Viewing in iPhone | 00:02:00 | ||
Power BI Service – Summary | 00:01:00 | ||
Working with Excel | |||
Working with Excel – Introduction | 00:01:00 | ||
Importing Excel Data using Simple Table | 00:02:00 | ||
Excel Workbook with Excel Data Model | 00:03:00 | ||
Connecting to Excel Workbook on OneDrive for Business | 00:05:00 | ||
Pinning Excel Tables or Visuals | 00:06:00 | ||
Analyzing Data in Excel | 00:03:00 | ||
Working with Excel – Summary | 00:01:00 | ||
Organization Packs, Security and Groups | |||
Organization Packs, Security and Groups – Introduction | 00:01:00 | ||
Creating a Group | 00:02:00 | ||
Creating a Content Pack | 00:02:00 | ||
Using a Content Pack | 00:02:00 | ||
Editing a Content Pack | 00:02:00 | ||
OneDrive for Business Integration | 00:03:00 | ||
Row Level Security | 00:05:00 | ||
Data Classification | 00:04:00 | ||
Organization Packs, Security and Groups – Summary | 00:01:00 | ||
Direct Connectivity | |||
Direct Connectivity – Introduction | 00:01:00 | ||
Direct Connectivity to SQL Azure | 00:00:00 | ||
Direct Connectivity to SQL Database | 00:04:00 | ||
Direct Connectivity to SSAS | 00:03:00 | ||
Using SSAS Connector | 00:03:00 | ||
SSAS Multi Dimensional Preview | 00:03:00 | ||
SAP HANA | 00:02:00 | ||
Direct Connectivity – Summary | 00:01:00 | ||
Developer API | |||
Developer API – Introduction | 00:01:00 | ||
Interactive API Console | 00:06:00 | ||
Registering a Client App and Embedding a Tile | 00:05:00 | ||
Using PubNub to Push Data to a Tile | 00:05:00 | ||
Using Custom Visuals | 00:06:00 | ||
Using Custom Visuals | 00:06:00 | ||
Power BI Embedded | 00:02:00 | ||
Mobile App | |||
Mobile App – Introduction | 00:06:00 | ||
Report Gallery and Search | 00:02:00 | ||
Mobile Dashboard Layout | 00:03:00 | ||
Sharing and Annotating in Power BI Mobile | 00:03:00 | ||
Taking Your Mobile Content Offline | 00:01:00 | ||
Platform Specific Features | 00:03:00 | ||
Search and Recent | 00:01:00 | ||
Limiting Access to Mobile + MAM | 00:02:00 | ||
Assessment | |||
Submit Your Assignment | 00:00:00 | ||
Certification | 00:00:00 |
Course Reviews
No Reviews found for this course.