All Services

From back-end infrastructure to personal productivity, Ergo has the knowledge and experience to match technology to all our client requirements. Our strength is understanding your business. The end goal is always the same, to make businesses more agile and competitive.

More About Our Services
Managed Services

Focus on your core business and leave ICT operations and management to the experts. From 24/7 service desk support to managing hybrid clouds, Ergo have the depth and experience to meet the most demanding service level requirements and ensure continuous improvement. 

More About Managed Services

Highlighted Services

Managed People

Competition for talented technology professionals is huge, which is why we make hiring more personal, taking time to match the right people to the right roles. Our technical experience and recruiting know-how help find the perfect fit for both parties.  

More About Managed People

Highlighted Services

Consultancy Services

Speed of change demands a new generation of digital investments that will drive business enablement and profitability. We support IT leaders, wherever they are on their digital transformation journeys, with our digital assessment methodology. 

More About Consultancy Services

Highlighted Services

Print and Document Solutions

Our goal is to deliver the best possible print and document service for you, leveraging the latest technologies and innovation to ensure the performance of your print environment is optimised to maximise employee productivity.  We take out costs, add efficiencies, wrap it in end-to-end security and make print integral to digital transformation. 

More About Print and Document Solutions

Highlighted Services

Cloud

Agility is key to business success and the cloud is where to get it. We offer a wide range of cloud services – public, private, hybrid – and provide the best of both worlds by integrating or migrating legacy systems to streamline the way your IT is consumed. 

More About Cloud

Highlighted Services

Digital Enablement

Ergo provides a clear roadmap for digital transformation with practical steps to make businesses more agile and customer-centric

More About Digital Enablement

Highlighted Services

Mobility and Collaboration

Ergo has provided many of Ireland’s largest organisations with an ecosystem of mobile applications and collaboration services that drive productivity without compromising on security

More About Mobility and Collaboration

Highlighted Services

Software Licensing

Businesses struggle to manage software assets and don’t always get the best value. We can help streamline your software purchasing, simplify deployments and maximise your investments. 

More About Software Licensing

Highlighted Services

Security, Risk and Compliance

Risks around cyber security and data protection are an ever-increasing challenge for businesses. We provide security lifecycle management, from perimeter testing and threat analysis to mitigating the impact of a breach. 

More About Security, Risk and Compliance

Highlighted Services

Microsoft Technology Specialisations

With the largest team of Microsoft IT professionals in Ireland – including two Most Valuable Professionals our expertise spans a comprehensive portfolio of products/services

More About Microsoft Technology Specialisations

Type your query and press the "Search now" button

Dashboard in a Day: 5 key points from the Power BI training session that will transform your business

Dashboard in a Day: 5 key points from the Power BI training session that will transform your business

Read The Article
Dashboard in a Day: 5 key points from the Power BI training session that will transform your business
Return to Blog

Dashboard in a Day: 5 key points from the Power BI training session that will transform your business

Over the recent months, we have been delivering “Dashboard in a Day” (DIAD) training sessions to businesses and IT decision makers, using Power BI technologies, at the new Microsoft building in Dublin. This is a Microsoft initiative which is designed to show users from a beginner or intermediate level the many uses and benefits which Power BI can potentially deliver for their reporting needs. DIAD is leading the way in making data analytics transparent for businesses. Decision makers are using it to understand where their data is coming from, and how they should use it to leverage competitive advantage.  

The content of the day’s training mainly consists of demos, followed by hands-on practical labs of Power BI Desktop and Power BI Service. Emphasis is placed on the labs as the step-by-step instructions allows the users to explore the many features of the tool, while in turn reaching the end goal of producing a report and dashboard.

We have delivered a number of sessions, with each session producing great results and gathering productive feedback. Not only did the users find some major benefits in the product, but our recurring Q&A got me thinking about other methods that could potentially be used within Power BI, to create reports specific business needs. It’s always good to talk and find out about the real-world/real-business experiences and how these can be remedied.

With that in mind, in this blog I am going to go through the features that captured the most attention in the DIAD sessions so far, the ones which provided solutions to real business problems and delivered a, what I like to call, “wow” factor for the attendees:

1. Transformation Capabilities

In several scenarios, if a user wanted to display or format a field in a particular way, or shape the whole information in a certain structure, then that usually meant fixing it at the source. If an Excel or flat file was the source, then modifications needed to be completed there first. If the source was in a location where it could not be edited directly, then that meant transformations or changes needed to take place there.

One of the powerful options in Power BI Desktop is the Query Editor, which enables many common transformations such as changing data types, adding new columns, splitting a column and merging and appending queries. Once the query is in the structure required, then all data can be refreshed with the transformations already in place, resulting in better formatting and display of reports.

2. Interactive Visualisations

After multiple visualisations have been added to a report, the power of interactivity between these report parts is immediately seen. Click a bar on a bar chart and see every other visualization change its output accordingly. Choose a location in a map visual and again all other charts, lists and KPIs will show values for this location. Also, sometimes you may not want a chart to be filtered based on choices within other visuals. This can be easily achieved in Power BI by turning off the filter on this chart.

Speed, clarity and structure is enhanced; leaving you spending less time on creating the reports, and more time analysing them and putting them into action.

3. Quick Measures

To create your own metric in a data set in Power BI, you can use DAX expressions. DAX is designed to be very similar to Excel functions, but takes away the hassle of getting bogged down in reams of Excel reports. To get needed information like, for example, last quarter’s net sales, this can be done very quickly and easily in a DAX function.

There are occasions when certain popular measures need to be derived and this means a more complex DAX expression (e.g. YTD, Month on Month Growth etc.) This is where the Quick Measures feature comes to the fore. For example, if you need to get YTD, running totals, averages, percentage differences and so on, then Quick Measures allows you to easily create these and produces the DAX expression for you, saving a lot of time.

4. Insights

Within Power BI is a feature that allows you to see the hidden information on your data. By choosing the Insights option on a chart, multiple charts are produced on this data that could potentially give you more astute metrics. When these insights provide helpful information, you can pin this visualization to your dashboard to revisit whenever needed.

For example, you can see clearly if more revenue is generated in a certain product category for a manufacturer, or if a country is showing noticeably less sales variances for a specific individual product. This opens up a level of never before seen transparency for your business, leading to identifying trends and saving on costs.

5. Compression and Performance

The data sources used in the DIAD training are multiple Excel and flat files. One of these Excel files contains over 11 million rows. Opening this sheet on your machine could hang Excel, and sometimes not all data will get loaded. Even if you do successfully open this file, you will have further issues in producing meaningful reporting information from this data in the form of pivots and charts.

Power BI will not have this problem. Millions of rows will be loaded and ready to be transformed in a short space of time. As well as this, the combined total storage for these individual files comes to 420 MB. Once loaded to Power BI Desktop, file size can be reduced to 50 MB. A massive saving on storage and, in turn, performance.

In summary

Dashboard in a Day is more than just a quick-fix lab session or demo; it equips businesses with the platform and technology needed to take full advantage of the data lying in their organisation. Data that is used properly will cut costs, improve transparency and help make better informed strategic decisions to keep an organisation moving forward in a competitive industry. Power BI does the technical work so you don’t have to, turning a tedious or difficult task in to a simple, business enhancing one.

If you are interested in doing your own Dashboard in a Day session to unlock the benefits of Power BI, please email experts@ergogroup.ie.

News and Blog Posts

Go with the Flow: 6 simple steps to implement a Microsoft Flow workflow for Dynamics 365
Juandre Germishuys
14 September 2018 • Posted By Juandre Germishuys Senior Software Developer

Go with the Flow: 6 simple steps to implement a Microsoft Flow workflow for Dynamics 365

In an ever-changing world of automation and end user enablement, Microsoft seem to just keep churning out more and more...

Read now
Finding Your IT Edge: Top Tips to Succeed in any Interview
Patrick Gibney
13 September 2018 • Posted By Patrick Gibney IT Recruitment Specialist

Finding Your IT Edge: Top Tips to Succeed in any Interview

Interviews can be daunting – this is fact. However, what a lot of people don’t realise is that...

Read now
Services in the Sky: Changing Clouds in a Shifting Landscape
News 05 September 2018

Services in the Sky: Changing Clouds in a Shifting Landscape

Read Now
Managed Print Services: A Journey into Detail
News 04 September 2018

Managed Print Services: A Journey into Detail

Read Now
Ergo and Micromail Scoop Two Partner of the Year Awards at Microsoft Inspire
News 20 July 2018

Ergo and Micromail Scoop Two Partner of the Year Awards at Microsoft Inspire

Read Now

Subscribe to Our Blog

Scroll to Top