Analyzing and Visualizing Data with
Microsoft Excel and Power BI
The course is designed to give you hands-on with data analysis and visualization in Excel, and equip you with a deep understanding of complex data visualization in Power BI.
The participant will engage with informative case studies that will help them engage with digital tools to work efficiently, report better and make informed decisions where big-data is involved.
1st – 4th April, 2020

Power BI is quickly gaining popularity among organization in helping them visualize data accurately. This tool helps team easily visualize and share insights from their organizations’ data. The course will be treating the data manipulation using Excel and advance business analysis using Power BI.
- Connect, import, shape, and transform data for business intelligence (BI)
- Visualize data, author reports, and schedule automated refresh of your reports
- Create and share dashboards based on reports in Power BI desktop and Excel
- Use natural language queries
- Create real-time dashboards
Course Content
Day 1
- Connect and Import from data sources.
- Perform transformations
- Cleanse data.
- Measure performance by using KPIs, gauges and
cards. - Create hierarchies.
Day 2
- Modelling and Visualizing Data
- Create and optimize data models.
- Create and manage Pivot Charts
Day 3
- Interact with Power BI
- Create and format interactive visualizations.
- Manage custom reporting solutions.
Day 4
- Configure Dashboards Reports and Apps in the
Power BI Service - Create calculated columns, calculated tables, and measures.
Data = Understanding
“The goal is to turn data into information, and information into insight.”
Date:
1st – 4th April, 2020
What We Do
TWPC Search and Placement
We offer a wide variety of services that will help our clients to hire the best people for your businesses.
Service DetailE-Learning
We offer both the platform and content and work with our clients to develop customized programs that would be hosted ...
Service DetailHR Consulting & Business Advisory
The TWPC consulting practice works with organisations to address their human / people performance issues leveraging the use of technology and providing insights and recommendations to solving these issues as well as the execution and deployment of strategy.
Service DetailTWPC Learning Academy
At TWPC, we work with our Clients to develop the requisite skills required to function optimally in the workplace and meet the increasing demands of the changing marketplace.
Service DetailERP Applications and ICT Consulting
We also provide consulting services to our corporate organizations who seek to improve their business processes using the latest technology available.
Service DetailRecent News
End Of Year Tune-up
END OF YEAR TUNE-UP What if your website, social media platforms, digital collateral, business processes, tools and the technology you employ ...
Read MoreTEAM DEVELOPMENT
Witnessing the coronavirus, COVID-19 make its mark across the world has been a harrowing experience for everyone as it has left ...
Read MoreCOVID-19: A LETTER TO OUR TEAM By Erik Reagan, CEO FOCUS LAB.
It’s been surreal to watch COVID-19 make its mark across the globe. From international coverage, national declarations, state-wide news conferences, and ...
Read MoreMusings from the COVID-19 Lockdown Season
Days roll into weeks and the weeks swing by. It’s all so surreal – Listening to the news and the deaths ...
Read MoreDigital Technology: The Connector and Game-changer
In a world filled with so many technological innovations, it seems unfathomable that a virus (COVID-19), invisible to the eye, would ...
Read MoreOur Clients
[logo_carousel_slider]