Enhance your technical skills by taking Power BI training from CyberSec from our certified experienced professionals and see how it leads to the next level of your career. CyberSec Academy delivers real-time and placement oriented Power BI training globablly. We Provide Best Power BI Course with live Projects and Practical Sessions.

Register Now

Why should you attend?

This instructor led custom training has been designed for enterprises that aim to empower their IT & Business users in Microsoft Power BI. The program typically lasts 2-3 days and is offered in three formats:

• Basic : Hands-on exercises that cover all aspects of self-service BI using the Power BI Desktop.
• Advanced : Customized training covering client data connectivity, DAX, Power Query Editor, and Power BI Service.
• Admin/IT : Best practices on administration of Power BI Desktop, O365 , data gateways and Azure cloud Integration.

Who should attend?

• Understand the role of Microsoft Power BI in their overall BI portfolio
• Create interactive visualizations and stories by connecting to various sources
• Collaborate with other users by preparing and sharing insights

Course Outline

INTRODUCTION
Power BI Desktop & Service
O365 and Architecture ACQUIRE DATA
Connecting to Flat files
Connecting to SAP BW & SAP HANA
Connecting to SQL Server, Oracle, Teradata
Connecting to Cloud Services & Platforms (e.g. Azure, OneDrive) ENRICH DATA
Merging and Appending Data
Editing/Cleansing Data
Building Custom, Date and Geo Hierarchies
Creating Custom Measures and Dimensions BUILD VISUALIZATION
Building Dynamic Dashboards
Using Charts & Geo Maps
Changing Text and Visualization Properties
One-Click Sorting & Conditional Formatting
Use Hyperlink Navigation’s SHARING INSIGHTS
Collaborate with Other Users
Export to PDF/PPT/Excel/CSV
Share Content Over Web and Mobile ADVANCED TOPICS (CUSTOMIZABLE)
Connecting To Client Data Sources & Exploring Use Cases
DAX Scripting, NLP, Quick Insights & Other Features
Best Practices

Course Agenda

Module 1: Introduction to Power BI (Duration-5hrs) Get Started with Power BI Overview: Power BI concepts Sign up for Power BI Overview: Power BI data sources Connect to a SaaS solution Upload a local CSV file Connect to Excel data that can be refreshed Connect to a sample Create a Report with Visualizations Explore the Power BI portal

Module 2: Viz and Tiles (Duration-5hrs) Overview: Visualizations Using visualizations Create a new report Create and arrange visualizations Format a visualization Create chart visualizations Use text, map, and gauge visualizations and save a report Use a slicer to filter visualizations Sort, copy, and paste visualizations Download and use a custom visual from the gallery

Module 3: Reports and Dashboards (Duration-10hrs) Modify and Print a Report Rename and delete report pages Add a filter to a page or report Set visualization interactions Print a report page Send a report to PowerPoint Create a Dashboard Create and manage dashboards Pin a report tile to a dashboard Pin a live report page to a dashboard Pin a tile from another dashboard Pin an Excel element to a dashboard Manage pinned elements in Excel Add a tile to a dashboard Build a dashboard with Quick Insights Set a Featured (default) dashboard Ask Questions about Your Data Ask a question with Power BI Q&A Tweak your datasets for Q&A Enable Cortana for Power BI

Module 4: Publishing Workbooks and Workspace (Duration-5hrs) Share Data with Colleagues and Others Publish a report to the web Manage published reports Share a dashboard Create an app workspace and add users Use an app workspace Publish an app Create a QR code to share a tile Embed a report in SharePoint Online

Module 5: Other Power BI Components and Table Relationship (Duration-5hrs) Use Power BI Mobile Apps Get Power BI for mobile View reports and dashboards in the iPad app Use workspace in the mobile app Sharing from Power BI Mobile Use Power BI Desktop Install and launch Power BI Desktop Get data Reduce data Transform data Relate tables Get Power BI Desktop data with the Power BI service Export a report from Power BI service to Desktop

Module 6: DAX functions (Duration-5hrs) New Dax functions Date and time functions Time intelligence functions Filter functions Information functions Logical functions Math & trig functions Parent and child functions Text functions

Certification

CyberSec Academy guarantees that the educational experience you gain will deliver value even after you complete the Training Course with its course completion certificate. This will undoubtedly be one of the valuable certifications for your career path and your first step in building a career in the Course. As part of this training, you will be working on real-time projects and assignments that have immense implications in the real world industry scenario thereby helping you fast track your career easily.

 

Become an asset to your organization with Microsoft Power BI certification.

Register below to signup for our upcoming training sessions.