Skip to content

Home
Services
Experience
People
- Our Team
About
Blog
Contact

Tag Archives: Azure Data Lake

Dan Evans

The USQL DateTime UTC/DST problem and how to fix it

The Problem Our Lake folder structure means that there is a folder per year/month/day for

About

Here the Adatis team share their musings and latest perspectives on all things advanced data analytics.

Categories

Categories

Adatis Authors

Tag Cloud

.NET AI Analysis Services Automation Azure Azure DataWarehouse Big Data Business Intelligence C# Dashboards data analytics Databricks Data Lake Data Science Data Warehousing ETL Excel Infrastructure Machine Learning Master Data Management Master Data Services MDM MDS MDX PerformancePoint PerformancePoint Server 2007 PowerApps Power BI PowerBI PowerBIDesktop PowerPivot Power Query Python R Reporting Services SQL SQL Server SQL Server 2005 SQL Server 2008 SSAS SSIS SSRS Tabular Utilities Visual Studio

Archives

Recent Comments

Data Science Training In Hyderabad on Data Science: what it is and why it matters
Drake on Parsing nested JSON lists in Databricks using Python
Larry on Introduction to Slowly Changing Dimensions (SCD) Types
CIALIS on Power BI Composite Models and Aggregations
Dataexpert010 on Data Science: what it is and why it matters

Office locations

Get in touch

Twitter latest

Adatis London
8 Boundary Row
London
SE1 8HP

Adatis Surrey
Farnham Business Park
Farnham
GU9 8QT

Adatis Bulgaria
Betahaus
Shipka 6 street, floor 3
1504 Sofia

0219 696 302(0) 44+

enquiries@adatis.co.uk

Twitter latest

In Microsoft’s recent eBook ‘Maximise your #PowerBI, Tableau and Qlik investments’ you’ll discover ways to: •Deliver even deeper insights faster. •Grant data access and insights globally. •Have security as your baseline. Download the eBook now: ow.ly/TNKl50zCOee pic.twitter.com/5U6x…

12:01 pm · 3rd June 2020

Adatis works with manufacturors to understand their data as the industry moves away from selling products, to selling services. The way data is collected, processed and stored is vital to stay ahead of the market in the age of manufacturing-as-a-service. adatis.co.uk/how-to-… pic.twitter.com/p6Dm…

8:01 am · 2nd June 2020

Maximise your organisation's success by assessing your readiness for rolling out #PowerBI, with Adatis. Our 2-week assessment offers recommendations on your current organisational data and governance process to keep you ahead of the game. Discover more. mailchi.mp/d2e813d87… pic.twitter.com/7nBx…

11:15 am · 1st June 2020

Have you seen the May #PowerBI feature updates? ow.ly/WfJt50zLkBf #PowerBIDesktop #PowerBIUpdate

10:01 am · 29th May 2020

Siloed #data meant @KingsCollegeLon was unable to get a clear picture of its operations for strategic planning. Adatis helped them implement a pan-university data lake & #analytics platform in #MSAzure See our video for more information: ow.ly/zWmo50zCNLA #MsPartner #Data pic.twitter.com/FyUw…

12:01 pm · 28th May 2020

In our latest blog from Kalina Ivanova, she showcases how to use bookmarks and selections features of Power BI to improve the interactivity and the overall user experience. ow.ly/g9O650zIUjS #PowerBI #PowerBIBookmarks #UserExperience pic.twitter.com/uLkv…

11:30 am · 27th May 2020

Last week a #MSBuild, Microsoft announced #AzureSynapse link. Want to find out more ? Take a look at this video fro Microsoft CTO, Azure Data @raghurwi ow.ly/kRfk50zKzri #AzureData #AzureCosmosDB #AzureSynapseLink pic.twitter.com/GOTN…

10:00 am · 26th May 2020

There have been some great announcements at #MSBuild. Missed them? Take a look at the summary here of all the news here: news.microsoft.com/b… #MsPartner #AzureData #AzureSynapse #AzureMachineLearning #ResponsibleML #AzureAI pic.twitter.com/mTds…

11:01 am · 22nd May 2020

Microsoft announce #AzureSynapse has moved to public preview. Azure Synapse brings two divided worlds together, the Data Lake and the Data Warehouse, into a single analytics service. Find out more in our latest blog: ow.ly/RyVF50zJ2eo #Analytics #Azure #PowerBI pic.twitter.com/Wp1G…

4:02 pm · 21st May 2020

#Microsoft recognized by #Forrester as a leader in #EnterpriseBI in latest report, "The Forrester Wave: Enterprise BI Platforms (Vendor-Managed), Q3 2019." Highest scores in strategy and market presence. Read the blog. ow.ly/qwIf50zIYuq

8:15 am · 20th May 2020

#MSBuild announcement - Unlock near real-time, no-ETL analytics at scale with #AzureSynapse Link for #AzureCosmosDB. Link your Cosmos DB account to Synapse & build real-time #PowerBI dashboards on top of your data in Cosmos DB Find out more here: ow.ly/G5gR50zKyub

5:01 pm · 19th May 2020

Microsoft’s #AzureMachineLearning platform enables AI for many organisations & streamlines the route to impactful, actionable insights. Find out more in our blog & how we can help you get started on your responsible ML journey: ow.ly/Qknm50zJiUp #MSBuild #ResponsibleML pic.twitter.com/HeMn…

3:10 pm · 19th May 2020

#PowerBI is continuously evolving, offering a variety of ways to analyse data for previously unknown patterns. However, with its high growth and updates, this comes with challenges. Find out how Adatis can offer a tried and tested model to overcome these. ow.ly/lIwi50yOVgb pic.twitter.com/wiMQ…

2:30 pm · 18th May 2020

As industries get more complex and competitive, a modern diverse data estate is vital to keeping ahead in a challenging market that focuses on innovation. Get more value from your data estate with Microsoft and Adatis! #DataModernisation ow.ly/BwUf50yV85s pic.twitter.com/iPxk…

10:15 am · 15th May 2020

At Adatis,our values are super important to us and are part of everything we do. We will be introducing you to all of our values with this series of blogs. First up - People First. ow.ly/l2Fz50z6DiO #CompanyValues #WorkplaceCulture #PeopleFirst pic.twitter.com/G1Mx…

11:30 am · 14th May 2020

In our most recent blog from David Stelfox (@stelfad )we look at finding duplicate objects following GIT merges ow.ly/3yy050zDWJ0 #GIT #GITmerges #VisualStudio pic.twitter.com/Q3Ia…

1:01 pm · 13th May 2020

Happy Nurses Day! Thank you to every nurse, doctor, paramedic, midwife or healthcare worker that make an fantastic contribution to societies around the world with the amazing worth they do. #NursesDay #ThankYou pic.twitter.com/YCOz…

10:01 am · 12th May 2020

We are proud of the work we have done enabling @KingsCollegeLon to embrace predictive analytics with a new pan-university data platform. Check out our customer success video ton how we helped Kings on their data journey ow.ly/4HcK50zytXQ #MsPartner #MSDataPlatform #MSAzure pic.twitter.com/8504…

11:01 am · 11th May 2020

We are proud to announce that we have been awarded Bronze in the @MindCharity Workplace Wellbeing Index 2019/20 in recognition of our commitment to prioritising the mental health of our staff. Find out more: ow.ly/xypr50zymsD #mindworkplaceawards #mentalhealthawareness pic.twitter.com/V70a…

11:25 am · 7th May 2020

In his latest blog, PowerBI expert @Data_Laz explains the various Connectivty Types that exist in #PowerBI: Import, #DirectQuery, #LiveConnection & Mixed mode and the pros & cons of using them ow.ly/11XX50zpzDx #PowerBITips pic.twitter.com/6tI1…

12:15 pm · 6th May 2020

Across the UK, #LocalGovernment is under severe pressure to eliminate cost, waste and delay from operational activities.Find out how the government is using data to reduce costs and improve service delivery to achieve even more. #PowerBI ow.ly/amol50yOWap pic.twitter.com/TIEA…

9:01 am · 6th May 2020

The Nonprofit Data Warehouse Quickstart helps #nonprofits capture their impact using by aggregating datasets that enable critical decision making & dependable reporting. Download now from #GitHub ow.ly/VoMw50zdutj #mspartner #MsAzure #dataanalytics #AzureDataWarehouse pic.twitter.com/BuYv…

10:01 am · 5th May 2020

As shoppers desire ethical brands could blockchain provide transparency? Studies show that 75% of shoppers would switch to a brand that offered in-depth information on its labels and 66% would pay more for products from a sustainable brand. Read the blog. ow.ly/SzTl50yOVzt pic.twitter.com/Nfv9…

1:15 pm · 4th May 2020

To ensure high performance, integrity, and the capabilities of #PowerBI, thought needs to go into the state of your data. Adatis offers proven models with recommendations to avoid the data chaos that organisations are faced with. #DataIntelligence ow.ly/7RtN50yOVSo pic.twitter.com/YDF2…

9:35 am · 1st May 2020

Last but not least, Tip number eight for dealing with workplace stress. Talk to someone. #StressAwarenessMonth pic.twitter.com/56Y8…

3:15 pm · 30th April 2020

2020 © Adatis all rights reserved Company Number: 05727383 VAT Registered: GB 887761165

Privacy and Cookie Policy

Home
Services
Experience
People
- Our Team
About
Blog
Contact
Customer Login