Skip to content

Home
Services
Experience
People
- Our Team
About
Blog
Contact

Tag Archives: Azure Data Lake

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

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

Archives

Recent Comments

Zach Stagers on Getting Started with Azure Purview
Barry Goold on Getting Started with Azure Purview
PMP Certification in Hyderabad on Data Science: what it is and why it matters
Jose Mendes on The Common Data Model in Azure Data Lake Storage – Export to Data Lake
Jose Mendes on The Common Data Model in Azure Data Lake Storage – Azure Data Services – Data Factory Data Flow

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

Adatis India
A5, 903, Kumar Palmgrove, Kondhwa Budruk, Pune 411048.
Mahrashtra, India.

0219 696 302(0) 44+

enquiries@adatis.co.uk

Let our experts operate, optimise and evolve your cloud, data and AI platform – allowing you to focus on your business. Find out more about how a Managed Service could help you - hubs.ly/H0BMpJk0 #DataManagedService #ManagedServices #MSPartner pic.twitter.com/HPto…

11:04 am · 20th January 2021

We would like to get your feedback by filling in our 5-minute survey on key features and benefits you look for when reviewing and comparing #DataCleansing, #DataQuality, and #MasterDataManagement solutions. Thank you for your time! hubs.la/H0DGt_70 pic.twitter.com/2dWf…

11:02 am · 19th January 2021

Data is the key to help Retailers to remain competitive in a competitive landscape. The Adatis Rapid Response Analytics Solution enables retailers to combine siloed data to uncover real-time, actionable data in days instead of months. hubs.ly/H0BMsFd0 #DataWarehouse pic.twitter.com/VH3N…

2:10 pm · 18th January 2021

Today is #BlueMonday, thought to be the most depressing day of the year. To help beat the blues, use today to get organised and focus on your goals for the week. Remember to reach out to friends or family if you feel like you need some support. #MentalHealth #WellbeingAtWork pic.twitter.com/KTcU…

11:10 am · 18th January 2021

Up next in our series of Meet the Team blogs we have Marketing Assistant, Catherine who joined us in 2019 after graduating from the University of Southampton. hubs.ly/H0BMs-j0 We hope you are enjoying getting to know the Adatis team better! #CompanyCulture #MeetTheTeam pic.twitter.com/j6H2…

1:36 pm · 15th January 2021

Andrius is joining us today and will be working as a Data Analytics Consultant, usually based from our London office, but will be working remotely for now. Welcome to the Adatis team! We look forward to getting to know you better #NewStarter #NowHiring #JobsInData #NewHire pic.twitter.com/8thp…

10:01 am · 15th January 2021

An update from our Senior Power BI Consultant, Laz, from our December newsletter - DirectQuery for PBI Datasets & Azure Analysis Services - Preview #PowerBI #DataVisualisation pic.twitter.com/NNmU…

11:58 am · 14th January 2021

Explore your data using Azure Data Explorer. Our new White paper covers important points about Azure Data Explorer including key features, use cases, architecture and collaboration methods. Read the White Paper - hubs.ly/H0BMpFr0 #AzureDataExplorer #DataArchitecture pic.twitter.com/9ujS…

11:07 am · 13th January 2021

This new blog by Senior Consultant, Zach, explores one of the key features of Purview: Data Lineage. What is it for, and what can and can't Purview do out of the box at the moment, and how do we use it? Read it here - hubs.la/H0DkkNl0 #AzurePurview #DataLineage pic.twitter.com/wr3J…

10:45 am · 12th January 2021

“Turn your data into insight” is a phrase so often heard. It sounds simple, yet anyone who’s ever faced the task of turning raw data into valuable business insight knows it’s anything but. This is where we come in. hubs.la/H0BMpDK0 #DataAnalytics pic.twitter.com/TEug…

2:03 pm · 11th January 2021

With Adatis managed services, this large restaurant group has turned its recently built data analytics solution into a powerhouse that delivers detailed insights from across the business, fast. Read the full Case Study hubs.ly/H0BMsz-0 #ManagedServices #MSPartner pic.twitter.com/AbmY…

11:04 am · 8th January 2021

The COVID-19 pandemic has sent shockwaves through the #retail sector and accelerated a major shift. Find out how data can help retailers re-capture their audiences and thrive during and post COVID-19. hubs.ly/H0Cnk7z0 #DataInRetail #DataAnalytics pic.twitter.com/5ufN…

1:29 pm · 7th January 2021

We're hiring! We're looking for data enthusiasts to join the Adatis team. If you think you have what it takes, apply today hubs.ly/H0DgqQk0 #DataAnalyticsJobs #CareersInTech pic.twitter.com/WvjH…

6:15 pm · 6th January 2021

With our 3-Day #PowerBI Proof of Concept, you can experience how you can shift from traditionally static reports and gain access to insightful and interactive reports that will help you in your data-driven journey. Find out more hubs.ly/H0BMsTV0 #DataVisualisation pic.twitter.com/Ri1o…

1:44 pm · 4th January 2021

Happy New year from everyone at Adatis! #HappyNewYear #2021 pic.twitter.com/r1oW…

10:00 am · 1st January 2021

The Adatis Data Warehouse Health Check is a packaged set of activities, designed to help organisations understand the value they are getting from their data warehouse and recognise and improvement opportunities. Find out more hubs.la/H0BMsd-0 #DataWarehouse #MDW pic.twitter.com/d6Gg…

8:15 am · 30th December 2020

Calling all data enthusiasts! We’re hiring for a number of positions in our Sofia office. If you want to be part of the Adatis team then find out more and apply today - hubs.ly/H0CR11v0 #NowHiring #JobsinTech #DataAnalyticsJobs pic.twitter.com/zFJs…

4:46 pm · 29th December 2020

Organisations have a wealth of information siloed in various sources & ingesting all this data into a central data lake is often hard. Simplify your data lake ingestion with The Adatis Rapid #DataLake Ingestion Service Find out more here hubs.ly/H0BMsdL0 #AzureDataLake pic.twitter.com/wt64…

11:10 am · 28th December 2020

Happy Holidays from everyone at Adatis! We hope you are all enjoying some well deserved time off! #HappyHolidays #MSPartner pic.twitter.com/UPec…

12:56 pm · 25th December 2020

We’re on the hunt for ambitious individuals to join our Adatis team in Sofia, Bulgaria. If you want the opportunity to work with the latest tech with a range of exciting clients, apply today - hubs.la/H0CR0NB0 #NowHiring #JobsinTech #DataAnalyticsJobs pic.twitter.com/LwUa…

9:09 am · 23rd December 2020

As this year draws to a close, we wanted to say a massive thank you to all of our customers, partners and everyone that follows us for your continued support. Happy Holidays everyone, from Adatis! #HappyHolidays #MSPartner pic.twitter.com/Jeo4…

10:58 am · 22nd December 2020

We want to introduce you to all the people who make Adatis great and up next is Junior Consultant Alex who started at Adatis on his placement year during University. Find out more about Alex and what he does at Adatis here - hubs.ly/H0BZcFx0 pic.twitter.com/Ml4y…

12:37 pm · 21st December 2020

We are currently hiring for a number of positions. If you want to work with some great clients on exciting tech then apply today! hubs.ly/H0BMs8K0 #JobsInData #CareersInData #DataAnalyticsJobs pic.twitter.com/3yS9…

4:06 pm · 19th December 2020

Recursive CTEs are a way to reference a query over and over again, until the deemed end point or the termination check, as it is called. Follow the example on Azure SQL Database in this new blog by Junior Consultant, Jeffin Matthew - hubs.ly/H0CnhP20 #DataAnalytics pic.twitter.com/Cjqy…

11:01 am · 17th December 2020

With contracts being regularly renewed, it is important to unify your data stream into one single view to gain maximum contract and supplier insight. Find out how Adatis works with #Local Authorities to be more cost effective. hubs.la/H0BMpwR0 #CostSpend #DataAnalaytics pic.twitter.com/lPEQ…

10:32 am · 16th December 2020

Home
Services
Experience
People
About
Blog
Contact

2021 © 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