This course has been designed to help the participants understand the concepts of data analytics and make use of them with Microsoft Excel. It starts by introducing data analytics concepts, business intelligence concepts and how data analytics and business intelligence are related. After that, participants will be taught how to connect Microsoft Excel with different data sources. Then afterwards, the course will go through extensive details on computational analysis and data analytics in Microsoft Excel. The participants will be shown how to use functions, pre-defined functions, conditional formatting, sorting tools, filtering, tables’ tools, pivot tables, D functions, Power Pivot tools, Power Query tools and Power Mapping tools. Following that, the concepts of data integration will be explained and practiced by going through different scenarios. Afterwards, participants will be shown how to make use of the data analytics tool in Microsoft Excel to generate different kinds of reports and dashboards. Throughout this course many tips, tricks and secrets will be shared that are the result of many years of work and research. At the same time, the course will be fully practical-based with hands-on cases and small-scale projects in order to develop a solid understanding of the concepts.
Connecting to multiple data sources:
Computational analysis and data management:
Useful Data Analytics outputs:
Our scheduled trainings are held in Ottawa, Montreal, Toronto and Vancouver. at the same time, we are able to provide our services to the other cites in Canada based on request.
We are a vibrant company in Canada specialized in delivering information technology training, consultancy, development services and data mining. Our focus is more into Business Intelligence....